package com.linln.modules.message.repository;

import com.linln.modules.message.domain.MessageInfo;
import com.linln.modules.message.domain.MessageMemberLog;
import com.linln.modules.system.repository.BaseRepository;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface MessageMemberLogRepository  extends JpaRepository<MessageMemberLog, Long> {

    @Modifying
    @Query(value = "SELECT  * FROM message_member_log WHERE message_id = ?1",nativeQuery=true)
    public List<MessageMemberLog> queryUserListByMessage(Long messageId);



}
